﻿CREATE TABLE [dbo].[Game] (
    [GameID]     INT IDENTITY (1, 1) NOT NULL,
    [SortOrder]  INT NULL,
    [WeekID]     INT NULL,
    [HomeTeam]   INT NULL,
    [AwayTeam]   INT NULL,
    [MondayGame] BIT NULL,
    CONSTRAINT [PK_Game] PRIMARY KEY CLUSTERED ([GameID] ASC),
    CONSTRAINT [FK_Game_Team] FOREIGN KEY ([HomeTeam]) REFERENCES [dbo].[Team] ([TeamID]),
    CONSTRAINT [FK_Game_Team1] FOREIGN KEY ([AwayTeam]) REFERENCES [dbo].[Team] ([TeamID]),
    CONSTRAINT [FK_Game_Week] FOREIGN KEY ([WeekID]) REFERENCES [dbo].[Week] ([WeekID])
);

